COV metadata

• COV provided us:
  • 92 videos.
  • The inspection form of each video is given to us as pdf file.
  • UBC Masters Program - AI - Inspection 2023-03-01.xlsx contains the inspected pipe properties
  • Gravity Main Inspections All_Inspections_UBC_AI.xlsx
  • Typical Frame width 720 or 640
  • Typical Frame Height 480
  • Frame rate 60 frames/second or 25 frames/second
  • 001626------:
    • Frame rate: 30 frames/second

Video file name

• The video is named using the following format: <Inspection ID>-<LEGACY_ID>-<Inspection Direction>-<Inspection Date>.mp4
• Example: 000019-__FJBYYX-D-2023-01-05.mp4
  • 000019 = Inspection ID or Reverse ID
  • __FJBYYX = LEGACY_ID
  • D = Inspection Direction
  • 2023-01-05 = Inspection Date

UBC Masters Program - AI - Inspection 2023-03-01.xlsx

• The numbers of unique ID stored in Inspection ID and the Reverse ID of each row indicate the number of CCTV videos corresponding to that particular pipe.
• Pipe id is stored in LEGACY_ID column

To match the video to xlsx file

• Match the different part of video file name to its corresponding column.

Gravity Main Inspections All_Inspections_UBC_AI.xlsx

• Sarah has provided excel file containing the detailed PACP code for each video in addtion to the pdf files.
• The excel file contains the detailed PACP code for 80 out of 92 videos uploaded by COV.